import pandas as pd
from pandas import DataFrame

excel_file_path = r'Documents\WorkBook.xlsx'


def standardize_column_name(df: DataFrame):
    column_names = []
    for column in df.columns:
        column_names.append(column.replace(' ', '_').lower())

    df.columns = column_names


def main():
    data_frames = pd.read_excel(excel_file_path, sheet_name=['Channels'], engine='openpyxl')

    df_channels = data_frames['Channels']
    standardize_column_name(df_channels)

    for channel_tuple in df_channels.itertuples():
        print(f'{channel_tuple.channel_name}, {channel_tuple.channel_detail}')


if __name__ == '__main__':
    main()
